<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/chenxiaotong1105/article/details/80581802"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql记录所有sql语句 - chenxiaotong1105的专栏"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql记录所有sql语句 - chenxiaotong1105的专栏 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "chenxiaotong1105";
        var blog_address = "https://blog.csdn.net/chenxiaotong1105";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/chenxiaotong1105/article/details/80581802"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql记录所有sql语句";
        var articleDesc = "有时候，为了定位问题，需要讲mysql上操作的所有sql语句记录。cat/etc/my.cnf在mysql的配置文件中[mysqld]中增加如下记录：general_log=1general_log_file=/var/lib/mysql/iZbp18qasm44xlfcjuuy76Z.logmysql还提供记录查询慢的sql记录。cat/etc/my.cnf在mysql的配置文件中[...";
        // 第四范式所需数据
        var articleTitles = "mysql记录所有sql语句 - chenxiaotong1105的专栏";
        
        var nickName = "就是大同";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/chenxiaotong1105/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/chenxiaotong1105/article/details/80581802";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql记录所有sql语句</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年06月05日 15:20:29</span>
                    <a class="follow-nickName" href="https://me.csdn.net/chenxiaotong1105" target="_blank">就是大同</a>
                    <span class="read-count">阅读数 1721</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            <p>有时候，为了定位问题，需要讲mysql上操作的所有sql语句记录。</p><p>cat /etc/my.cnf<br /></p><p><span style="font-size:18px;background-color:rgb(255,255,255);">在mysql的配置文件中[mysqld]中增加如下记录：</span><br /></p><p>general_log = 1<br /></p><p>general_log_file = /var/lib/mysql/iZbp18qasm44xlfcjuuy76Z.log</p><p><br /></p><p>mysql还提供记录查询慢的sql记录。</p><p>cat /etc/my.cnf<br /></p><p><span style="font-size:18px;background-color:rgb(255,255,255);">在mysql的配置文件中[mysqld]中增加如下记录：</span><br /></p><p>slow_query_log = on<br />slow-query-log-file = /var/lib/mysql/slowquery.log<br /></p><p>long_query_time = 2</p><p>ps：5.7和5.7以前的字段名称不一致。本配置为5.7的配置。</p><p><br /></p><p></p><p style="background-color:rgb(255,255,255);"><span style="font-size:18px;"><span style="color:rgb(68,68,68);font-family:'WenQuanYi Micro Hei Mono', 'WenQuanYi Micro Hei', 'Microsoft Yahei Mono', 'Microsoft Yahei', sans-serif, Simsun;line-height:27px;">在MySQL 5.7.2 新增了 log_timestamps 这个参数，该参数主要是控制 error log、genera log，等等记录日志的显示时间参数，</span></span><span style="font-size:18px;">且默认安装后error_log,slow_log 日志时间戳默认为UTC，因此会造成与系统时间不一致，与北京时间相差8个小时</span></p><p style="background-color:rgb(255,255,255);">SHOW GLOBAL VARIABLES LIKE 'log_timestamps';<br />+---------------------+-------------------+<br />|Variable_name  |              Value   |<br />+---------------------+-------------------+<br />|log_timestamps |              UTC     |<br />+---------------------+-------------------+<br /></p><p style="background-color:rgb(255,255,255);"><span style="font-size:18px;">因为</span><span style="font-size:18px;color:rgb(68,68,68);font-family:'WenQuanYi Micro Hei Mono', 'WenQuanYi Micro Hei', 'Microsoft Yahei Mono', 'Microsoft Yahei', sans-serif, Simsun;line-height:27px;">log_timestamps  </span><span style="font-size:18px;">是一个GLOBAL的全局参数,</span><span style="font-size:18px;">所以直接在登录后去set全局参数,重启后就会直接失效</span></p><p style="background-color:rgb(255,255,255);"><span style="font-size:18px;">因此需要在mysql的配置文件中[mysqld]中增加一条</span><span style="color:rgb(68,68,68);font-family:'WenQuanYi Micro Hei Mono', 'WenQuanYi Micro Hei', 'Microsoft Yahei Mono', 'Microsoft Yahei', sans-serif, Simsun;font-size:18px;line-height:27px;">log_timestamps的配置</span></p><p style="background-color:rgb(255,255,255);"><span style="color:rgb(68,68,68);font-family:'WenQuanYi Micro Hei Mono', 'WenQuanYi Micro Hei', 'Microsoft Yahei Mono', 'Microsoft Yahei', sans-serif, Simsun;font-size:18px;line-height:27px;">log_timestamps=SYSTEM</span></p><br />                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/chenxiaotong1105/article/details/80581802","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/chenxiaotong1105/article/details/80581802","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="80581802">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010138380/article/details/47603775","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010138380/article/details/47603775" target="_blank" title="常见的SQL语法">
		<h4 class="text-truncate oneline">
				常见的<em>SQL</em>语法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-14</span>
				<span class="read-num hover-hide">
					阅读数 
					916</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010138380/article/details/47603775" target="_blank" title="常见的SQL语法">
				<span class="desc oneline">一：SQL简介：SQL语句是对所有的关系型数据库的通用命令语句，而JDBCAPI只是执行SQL语句的一个工具。当然每种数据库也为了实现特有功能有自己特殊的语句，但是为了实现跨平台我们应该减少特定功能的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010138380">来自：	<span class="blog_title"> 细节决定成败</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fashion2014/article/details/78826299","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fashion2014/article/details/78826299" target="_blank" title="sql语句练习50题(Mysql版)">
		<h4 class="text-truncate oneline">
				<em>sql</em><em>语句</em>练习50题(<em>Mysql</em>版)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-19</span>
				<span class="read-num hover-hide">
					阅读数 
					12万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fashion2014/article/details/78826299" target="_blank" title="sql语句练习50题(Mysql版)">
				<span class="desc oneline">习题来源于网络，sql语句是自己写的。欢迎指正。表名和字段–1.学生表Student(s_id,s_name,s_birth,s_sex)–学生编号,学生姓名,出生年月,学生性别–2.课程表Cours...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fashion2014">来自：	<span class="blog_title"> 风一样的勇士</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a2416743126/article/details/78730740","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a2416743126/article/details/78730740" target="_blank" title="基础的 mysql  sql 语句，简单篇，拿起就用">
		<h4 class="text-truncate oneline">
				基础的 <em>mysql</em>  <em>sql</em> <em>语句</em>，简单篇，拿起就用		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-06</span>
				<span class="read-num hover-hide">
					阅读数 
					3056</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a2416743126/article/details/78730740" target="_blank" title="基础的 mysql  sql 语句，简单篇，拿起就用">
				<span class="desc oneline"></span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a2416743126">来自：	<span class="blog_title"> 隐士的远方</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xxx9001/article/details/53832524","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xxx9001/article/details/53832524" target="_blank" title="三种记录 MySQL 所执行过的 SQL 语句的方法">
		<h4 class="text-truncate oneline">
				三种<em>记录</em> <em>MySQL</em> 所执行过的 <em>SQL</em> <em>语句</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-23</span>
				<span class="read-num hover-hide">
					阅读数 
					5160</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xxx9001/article/details/53832524" target="_blank" title="三种记录 MySQL 所执行过的 SQL 语句的方法">
				<span class="desc oneline">程式Debug有時後從前面第一行追起來很辛苦(程式碼太多或compile過),另一種做法就是從後面追起來,反正最後寫入的是DB,那就從DB開始往前推,所以就是要抓程式是執行哪些SQL語法.(以下只以M...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xxx9001">来自：	<span class="blog_title"> 一只烦恼的猪</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chenxiaotong1105/article/details/80581358","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chenxiaotong1105/article/details/80581358" target="_blank" title="mysql恢复库表结构">
		<h4 class="text-truncate oneline">
				<em>mysql</em>恢复库表结构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-05</span>
				<span class="read-num hover-hide">
					阅读数 
					525</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chenxiaotong1105/article/details/80581358" target="_blank" title="mysql恢复库表结构">
				<span class="desc oneline">mysql恢复库表结构1.通过每天备份的sql文件恢复在服务器上创建crontab定时任务,每日凌晨全部备份数据库,并发送到文件服务器上。mysqldump--host=${DBHOST}-u${DB...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chenxiaotong1105">来自：	<span class="blog_title"> chenxiaotong1105的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011022919/article/details/80684395","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011022919/article/details/80684395" target="_blank" title="mysql记录所有执行过的SQL">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>记录</em><em>所有</em>执行过的<em>SQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2421</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011022919/article/details/80684395" target="_blank" title="mysql记录所有执行过的SQL">
				<span class="desc oneline">先showvariables看看都有哪些变量是控制这个日志记录的|general_log   |OFF||general_log_file|/data/mysql/localhost.log|看到没?...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011022919">来自：	<span class="blog_title"> u011022919的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_36698956/article/details/83347755","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_36698956/article/details/83347755" target="_blank" title="MySQL开启日志记录查询/执行过的SQL语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>开启日志<em>记录</em>查询/执行过的<em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-24</span>
				<span class="read-num hover-hide">
					阅读数 
					947</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_36698956/article/details/83347755" target="_blank" title="MySQL开启日志记录查询/执行过的SQL语句">
				<span class="desc oneline">MySQL开启日志记录查询/执行过的SQL语句前眼运用场景临时开启Log步骤1.查看LOG功能打开Log功能（临时性）永久开启Log步骤1.需要编辑my.cnf文件2.重启mysql生效3.实时查看/...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_36698956">来自：	<span class="blog_title"> 探索丶挑战丶突破</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/mybwu_com/article/details/84523071","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mybwu_com/article/details/84523071" target="_blank" title="mysql如何跟踪执行的sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>如何跟踪执行的<em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-26</span>
				<span class="read-num hover-hide">
					阅读数 
					22</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mybwu_com/article/details/84523071" target="_blank" title="mysql如何跟踪执行的sql语句">
				<span class="desc oneline">在SQLSERVER下跟踪sql采用事件探查器，而在mysql下如何跟踪sql呢？其实方法很简单，开启mysql的日志log功能，通过查看跟踪日志即可。开启mysql的日志log方法：windows环...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mybwu_com">来自：	<span class="blog_title"> mybwu_com的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010316405/article/details/48137861","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010316405/article/details/48137861" target="_blank" title="mysql查看历史执行的sql">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看历史执行的<em>sql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-31</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010316405/article/details/48137861" target="_blank" title="mysql查看历史执行的sql">
				<span class="desc oneline">查看mysql的语句,比较常用的大概是showprocesslist命令了,但是这个对于查询时间比较长的语句比较有意义,对于一下子就能执行的语句真心拼不过手速啊.于是就只能从mysql的历史记录里面着...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010316405">来自：	<span class="blog_title"> u010316405的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_29579431/article/details/89328902","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_29579431/article/details/89328902" target="_blank" title="Mysql记录历史执行的sql">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>记录</em>历史执行的<em>sql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-16</span>
				<span class="read-num hover-hide">
					阅读数 
					423</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_29579431/article/details/89328902" target="_blank" title="Mysql记录历史执行的sql">
				<span class="desc oneline">1.在mysql中执行下面这条语句查看记录历史工具是否打开，以及log路径。showvariableslike&quot;gener%&quot;;mysql结果：|general_log|OFF||general_lo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_29579431">来自：	<span class="blog_title"> qq_29579431的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/huazi88888/article/details/8567599","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huazi88888/article/details/8567599" target="_blank" title="如何知道一个session都执行过哪些SQL语句">
		<h4 class="text-truncate oneline">
				如何知道一个session都执行过哪些<em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-03</span>
				<span class="read-num hover-hide">
					阅读数 
					2369</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huazi88888/article/details/8567599" target="_blank" title="如何知道一个session都执行过哪些SQL语句">
				<span class="desc oneline">如何知道一个session都执行过哪些SQL语句（查看当前比较容易，历史的呢？怎么复原sql的执行场景——事务关系、执行序列、单SQL还是存储过程）【方法一】查询v$sqltext、v$sqlarea...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huazi88888">来自：	<span class="blog_title"> Elliot_华子的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qidaif/article/details/80931703","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qidaif/article/details/80931703" target="_blank" title="MySQL查看实时执行的SQL语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查看实时执行的<em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-05</span>
				<span class="read-num hover-hide">
					阅读数 
					8095</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qidaif/article/details/80931703" target="_blank" title="MySQL查看实时执行的SQL语句">
				<span class="desc oneline">MySQL默认不能实时查看执行的SQL语句，因为这会消耗一定的资源。要开启这个功能，稍微配置一下，打开这个LOG记录就可以了。1查看LOG功能首先，查看是否已经开启实时SQL语句记录。mysql&amp;am...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qidaif">来自：	<span class="blog_title"> qidaif的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"http://ask.csdn.net/questions/718546","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<a href="http://ask.csdn.net/questions/718546" target="_blank">
		<h4 class="text-truncate oneline">
				请问怎么写查询<em>sql</em> ,  能查到前一天插入的最后一批数据		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-26</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_27471405/article/details/79495816","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_27471405/article/details/79495816" target="_blank" title="pl sql 查看历史执行过的sql记录">
		<h4 class="text-truncate oneline">
				pl <em>sql</em> 查看历史执行过的<em>sql</em><em>记录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-09</span>
				<span class="read-num hover-hide">
					阅读数 
					8128</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_27471405/article/details/79495816" target="_blank" title="pl sql 查看历史执行过的sql记录">
				<span class="desc oneline">现在越来越多人用plsql查询和执行sql，因为该工具很方便，不仅可以执行sql、以及命令窗口，但是呢，有时候我们执行完sql，可能忘记保存或者当时觉得可能不怎么重要，就没有保存，等到了第二天或者过段...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_27471405">来自：	<span class="blog_title"> 小小鱼儿小小林的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hgg923/article/details/77884232","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hgg923/article/details/77884232" target="_blank" title="mysql查看当前运行中或挂起的sql">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看当前运行中或挂起的<em>sql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-07</span>
				<span class="read-num hover-hide">
					阅读数 
					2936</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hgg923/article/details/77884232" target="_blank" title="mysql查看当前运行中或挂起的sql">
				<span class="desc oneline">查看执行、挂起的sql列表：showprocesslist杀死进程：killid</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hgg923">来自：	<span class="blog_title"> hgg923的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hahoo2009/article/details/93896259","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hahoo2009/article/details/93896259" target="_blank" title="MYSQL日志输出所有SQL语句">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>日志输出<em>所有</em><em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-27</span>
				<span class="read-num hover-hide">
					阅读数 
					49</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hahoo2009/article/details/93896259" target="_blank" title="MYSQL日志输出所有SQL语句">
				<span class="desc oneline">最简单有效的办法，在JDBC连接MYSQL参数中加上&amp;amp;logger=com.mysql.jdbc.log.Slf4JLogger&amp;amp;profileSQL=true日志输出格式样例：201...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hahoo2009">来自：	<span class="blog_title"> 码者不惑</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392558531","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<a href="https://bbs.csdn.net/topics/392558531" target="_blank">
		<h4 class="text-truncate oneline">
				如何查看<em>mysql</em>数据库操作<em>记录</em>日志？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-25</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">1、首先确认你日志是否启用了mysql&gt;show variables like 'log_bin'。 2、如果启用了，即ON，那日志文件就在mysql的安装目录的data目录下。 3、怎样知道当前的日</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33720078/article/details/86131040","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33720078/article/details/86131040" target="_blank" title="怎么打开/查看MySQL的SQL记录">
		<h4 class="text-truncate oneline">
				怎么打开/查看<em>MySQL</em>的<em>SQL</em><em>记录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-22</span>
				<span class="read-num hover-hide">
					阅读数 
					136</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33720078/article/details/86131040" target="_blank" title="怎么打开/查看MySQL的SQL记录">
				<span class="desc oneline">mysql在执行sql的时候会在日志当中记录很多信息，当然包括执行的所有语句。下面以使用navicatformysql为例，来展示一下如何打开/查看MySQL的SQL记录：打开navicatformy...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33720078">来自：	<span class="blog_title"> weixin_33720078的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_16131/article/details/82512098","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_16131/article/details/82512098" target="_blank" title="mysql 2个sql更新不同记录但死锁">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 2个<em>sql</em>更新不同<em>记录</em>但死锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-02</span>
				<span class="read-num hover-hide">
					阅读数 
					155</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_16131/article/details/82512098" target="_blank" title="mysql 2个sql更新不同记录但死锁">
				<span class="desc oneline">问题起因：两条写sql，操作的记录没有任何冲突，但发生死锁 预备知识：InnoDB行锁是通过给索引上的索引项加锁来实现的 创建测试表CREATETABLE`t1`( `pk_id`INT(11)NOT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_16131">来自：	<span class="blog_title"> 海阔天空</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392267035","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<a href="https://bbs.csdn.net/topics/392267035" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库查询某条数据更新<em>记录</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">09-22</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql数据库有一张表，表里有一条数据，主键为流水号。请问如何查询这条数据的更改记录。急急急急急。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012082699/article/details/42504071","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012082699/article/details/42504071" target="_blank" title="常用的Mysql数据库操作语句大全">
		<h4 class="text-truncate oneline">
				常用的<em>Mysql</em>数据库操作<em>语句</em>大全		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-07</span>
				<span class="read-num hover-hide">
					阅读数 
					126</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012082699/article/details/42504071" target="_blank" title="常用的Mysql数据库操作语句大全">
				<span class="desc oneline">零、用户管理：　　1、新建用户：　　　　&gt;CREATEUSERnameIDENTIFIEDBY'ssapdrow';　　2、更改密码：　　　　&gt;SETPASSWORDFORname=PASSWORD(...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012082699">来自：	<span class="blog_title"> 孫小聖的学习之路</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/finalkof1983/article/details/84450896","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/finalkof1983/article/details/84450896" target="_blank" title="MySQL中一条SQL语句的执行过程">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中一条<em>SQL</em><em>语句</em>的执行过程		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-24</span>
				<span class="read-num hover-hide">
					阅读数 
					2920</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/finalkof1983/article/details/84450896" target="_blank" title="MySQL中一条SQL语句的执行过程">
				<span class="desc oneline">查询语句的执行顺序：１.客户端通过TCP连接发送连接请求到mysql连接器，连接器会对该请求进行权限验证及连接资源分配（max_connections，8小时超时）２.建立连接后客户端发送一条语句，m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/finalkof1983">来自：	<span class="blog_title"> 一梦如是的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hzw6991/article/details/87757426","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hzw6991/article/details/87757426" target="_blank" title="mysql sql常用语句大全">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>sql</em>常用<em>语句</em>大全		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1223</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hzw6991/article/details/87757426" target="_blank" title="mysql sql常用语句大全">
				<span class="desc oneline">一、常用操作数据库的命令1.showdatabases;查看所有的数据库2.createdatabasetest;创建一个叫test的数据库3.dropdatabasetest;删除一个叫test的数...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hzw6991">来自：	<span class="blog_title"> 神奇的老黄</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32648375/article/details/83687048","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_32648375/article/details/83687048" target="_blank" title="mysql数据库常用sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库常用<em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-03</span>
				<span class="read-num hover-hide">
					阅读数 
					4524</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_32648375/article/details/83687048" target="_blank" title="mysql数据库常用sql语句">
				<span class="desc oneline">数据库可以用图形化工具来实现一系列操作，这里涉及一些cmd命令行首先要配置好环境变量可以全局操作命令，不然只能在mysql的安装目录下进行操作，这里不再叙述1.进入数据库：mysql-uroot-p（...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_32648375">来自：	<span class="blog_title"> 07151012的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32998153/article/details/81747643","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_32998153/article/details/81747643" target="_blank" title="Sql语句的执行原理-MySQL">
		<h4 class="text-truncate oneline">
				<em>Sql</em><em>语句</em>的执行原理-<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1763</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_32998153/article/details/81747643" target="_blank" title="Sql语句的执行原理-MySQL">
				<span class="desc oneline">第一步：应用程序把查询SQL语句发送给服务器端执行。我们在数据库层执行SQL语句时，应用程序会连接到相应的数据库服务器，把SQL语句发送给服务器处理。第二步：查询缓存服务器在解析一个查询语句之前，如果...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_32998153">来自：	<span class="blog_title"> qq_32998153的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_41843699/article/details/91127475","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_41843699/article/details/91127475" target="_blank" title="Mysql基本语句">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>基本<em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1251</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_41843699/article/details/91127475" target="_blank" title="Mysql基本语句">
				<span class="desc oneline">一、SQL概述结构化查询语言(StructuredQueryLanguage)简称SQL，是一种特殊目的的编程语言，是一种数据库查询和程序设计语言，用于存取数据以及查询、更新和管理关系数据库系统，同时...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_41843699">来自：	<span class="blog_title"> 菜鸟、上路</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/machen_smiling/10017779","strategy":"BlogCommendFromBaidu","index":"26"}'>
		<a href="https://download.csdn.net/download/machen_smiling/10017779" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>MySQL</em> <em>SQL</em>查询<em>语句</em>大全集锦(经典珍藏)					</h4>
					<span class="data float-right">10-12</span>
				</div>
				<div class="desc oneline">
						MySQL SQL查询语句大全集锦(经典珍藏),可以每天练习的				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xuebing1995/article/details/74614896","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xuebing1995/article/details/74614896" target="_blank" title="MySQL 50条必练查询语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 50条必练查询<em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-06</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xuebing1995/article/details/74614896" target="_blank" title="MySQL 50条必练查询语句">
				<span class="desc oneline">Student(S#,Sname,Sage,Ssex)学生表Course(C#,Cname,T#)课程表SC(S#,C#,score)成绩表Teacher(T#,Tname)教师表问题：1、查询“00...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xuebing1995">来自：	<span class="blog_title"> 发呆的程序猿</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/DrDanger/article/details/79092808","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/DrDanger/article/details/79092808" target="_blank" title="MySQL之SQL语句优化步骤">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>之<em>SQL</em><em>语句</em>优化步骤		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-18</span>
				<span class="read-num hover-hide">
					阅读数 
					8672</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/DrDanger/article/details/79092808" target="_blank" title="MySQL之SQL语句优化步骤">
				<span class="desc oneline">MySQL查询截取分析步骤：一、开启慢查询日志，捕获慢SQL二、explain+慢SQL分析三、showprofile查询SQL语句在服务器中的执行细节和生命周期四、SQL数据库服务器参数调优一、开启...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/DrDanger">来自：	<span class="blog_title"> DrDanger的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_36539304/article/details/70861067","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_36539304/article/details/70861067" target="_blank" title="MySQL常用sql语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>常用<em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					5486</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_36539304/article/details/70861067" target="_blank" title="MySQL常用sql语句">
				<span class="desc oneline">1、使用sql对数据库操作连接数据库命令：mysql-uroot-p密码创建数据库：createdatabasedbname;查看所有的数据库：showdatabases;删除数据库：dropdata...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_36539304">来自：	<span class="blog_title"> 散神的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/studyphp123/article/details/83747028","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/studyphp123/article/details/83747028" target="_blank" title="【PHP面试题】MySQL的SQL语句编写">
		<h4 class="text-truncate oneline">
				【PHP面试题】<em>MySQL</em>的<em>SQL</em><em>语句</em>编写		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-05</span>
				<span class="read-num hover-hide">
					阅读数 
					447</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/studyphp123/article/details/83747028" target="_blank" title="【PHP面试题】MySQL的SQL语句编写">
				<span class="desc oneline">文章目录一、考点1、MySQL的关联UPDATE语句关联更新2、延伸：MySQL的关联查询语句六种关联查询：1）交叉连接（`CROSSJOIN`）注：没有任何关联条件，结果是笛卡尔积，结果集会很大，没...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/studyphp123">来自：	<span class="blog_title"> studyphp123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/50455983","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<a href="https://bbs.csdn.net/topics/50455983" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mySql</em>中在哪写<em>SQL</em><em>语句</em>啊		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-24</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">第一次用mySql,啥也不懂，大家不要窃笑， 我装的是mysql-4.0.14，不知道在哪编辑运行SQL语句， 就象SqlServer的查询编辑器那样的东东， 多谢！！</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390578484","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<a href="https://bbs.csdn.net/topics/390578484" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 每天在00:00:00 执行一条<em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">09-03</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">前段时间我再csdn：http://bbs.csdn.net/topics/390571394发布了一条提问,但是他们的回复有问题，不能达到每天固定时间执行sql语句。 求大神回复 提问:mysql中</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Hanrovey/article/details/68922073","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Hanrovey/article/details/68922073" target="_blank" title="［MySQL学习］常用SQL语句大全总结">
		<h4 class="text-truncate oneline">
				［<em>MySQL</em>学习］常用<em>SQL</em><em>语句</em>大全总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Hanrovey/article/details/68922073" target="_blank" title="［MySQL学习］常用SQL语句大全总结">
				<span class="desc oneline">转载地址：http://www.cnblogs.com/0351jiazhuang/p/4530366.htmlSQL是(StructuredQueryLanguage)结构化查询语言的简称，下面赵一...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Hanrovey">来自：	<span class="blog_title"> Hanrovey Blog</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392301885","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<a href="https://bbs.csdn.net/topics/392301885" target="_blank">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>sql</em><em>语句</em>优化问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-26</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">sql语句： SELECT o.order_id, SUM(o.discountAmount) AS discountAmount, s.store_name, o.create_time AS cr</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391817914","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<a href="https://bbs.csdn.net/topics/391817914" target="_blank">
		<h4 class="text-truncate oneline">
				如何将写好的<em>sql</em><em>语句</em>导入到数据库中？<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">08-27</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">请尽量说得详细一点。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sinat_29673403/article/details/70859682","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinat_29673403/article/details/70859682" target="_blank" title="mysql中sql语句的妙用">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中<em>sql</em><em>语句</em>的妙用		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1182</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinat_29673403/article/details/70859682" target="_blank" title="mysql中sql语句的妙用">
				<span class="desc oneline">大家应该都对sql语句特别熟悉，但是对于不同的人来说用sql语句操作数据库取出自己想要的数据及数据格式的方式都不尽相同。那么，我在这里抛砖引玉的介绍一下我在面对特定的某些需求数据的时候是如何使用sql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinat_29673403">来自：	<span class="blog_title"> 忆浅曦</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lzj0470/article/details/83940991","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lzj0470/article/details/83940991" target="_blank" title="mysql explain 笔记整理">
		<h4 class="text-truncate oneline">
				<em>mysql</em> explain 笔记整理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-04</span>
				<span class="read-num hover-hide">
					阅读数 
					59</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lzj0470/article/details/83940991" target="_blank" title="mysql explain 笔记整理">
				<span class="desc oneline">explain是用来分析sql语句，帮助优化的一个命令。explain的语法如下：[code=&amp;quot;java&amp;quot;]explain[extended]select…from…where…[...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lzj0470">来自：	<span class="blog_title"> lzj0470的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jielione/article/details/8230797","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jielione/article/details/8230797" target="_blank" title="mysql sql语句大全">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>sql</em><em>语句</em>大全		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-27</span>
				<span class="read-num hover-hide">
					阅读数 
					3833</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jielione/article/details/8230797" target="_blank" title="mysql sql语句大全">
				<span class="desc oneline">?1、说明：创建数据库CREATE DATABASE database-name2、说明：删除数据库drop database dbname3、说明：备份sqlserver---创建备份数据的devi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jielione">来自：	<span class="blog_title"> jielione的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jay5566/article/details/6290813","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jay5566/article/details/6290813" target="_blank" title="经典的SQL语句 之三">
		<h4 class="text-truncate oneline">
				经典的<em>SQL</em><em>语句</em> 之三		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-31</span>
				<span class="read-num hover-hide">
					阅读数 
					153</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jay5566/article/details/6290813" target="_blank" title="经典的SQL语句 之三">
				<span class="desc oneline">　1、说明：复制表(只复制结构,源表名：a新表名：b)(Access可用)　　法一：select*intobfromawhere11　　法二：selecttop0*intobfroma 　　2、说明：...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jay5566">来自：	<span class="blog_title"> jay5566的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaodongxiexie/article/details/78541160","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaodongxiexie/article/details/78541160" target="_blank" title="常用sql语句（mysql）">
		<h4 class="text-truncate oneline">
				常用<em>sql</em><em>语句</em>（<em>mysql</em>）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-15</span>
				<span class="read-num hover-hide">
					阅读数 
					302</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaodongxiexie/article/details/78541160" target="_blank" title="常用sql语句（mysql）">
				<span class="desc oneline">#给表新增列sql='''altertabletable_nameaddcolumncol_namevarchar(255)notnulldefaultdefault_value'''#增加表列，指定...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaodongxiexie">来自：	<span class="blog_title"> Great haste makes great waste</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/phoebird/article/details/2797961","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/phoebird/article/details/2797961" target="_blank" title="mysql命令行命令和SQL语句 ">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令行命令和<em>SQL</em><em>语句</em> 		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-19</span>
				<span class="read-num hover-hide">
					阅读数 
					7460</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/phoebird/article/details/2797961" target="_blank" title="mysql命令行命令和SQL语句 ">
				<span class="desc oneline"> 一 .常用mysql命令行命令      1.启动MYSQL服务  netstartmysql停止MYSQL服务  netstopmysql       2.netstat–na|findstr33...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/phoebird">来自：	<span class="blog_title"> 幽狼</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiaoxik/article/details/76400749","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaoxik/article/details/76400749" target="_blank" title="mysql  sql语句总结">
		<h4 class="text-truncate oneline">
				<em>mysql</em>  <em>sql</em><em>语句</em>总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-30</span>
				<span class="read-num hover-hide">
					阅读数 
					196</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaoxik/article/details/76400749" target="_blank" title="mysql  sql语句总结">
				<span class="desc oneline">select：1、limit字句selectprod_namefromproductslimit5;使用select语句检索单个列，limit5表示返回不多于5行。selectprod_namefro...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaoxik">来自：	<span class="blog_title"> xiaoxik的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weijunyuan1019/article/details/6409267","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weijunyuan1019/article/details/6409267" target="_blank" title="mysql 语句大全（很实用的哦！）">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>语句</em>大全（很实用的哦！）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					427</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weijunyuan1019/article/details/6409267" target="_blank" title="mysql 语句大全（很实用的哦！）">
				<span class="desc oneline">mysqlsql语句大全	作者：yfProgramer  来源：博客园  发布时间：2011-04-1211:23  阅读：12次  原文链接  	[收藏]  viewsourceprint?1、说明...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weijunyuan1019">来自：	<span class="blog_title"> 老魏天地</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/x_i_y_u_e/article/details/51147588","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/x_i_y_u_e/article/details/51147588" target="_blank" title="mysql查询语句实例 复杂mysql查询">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查询<em>语句</em>实例 复杂<em>mysql</em>查询		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-13</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/x_i_y_u_e/article/details/51147588" target="_blank" title="mysql查询语句实例 复杂mysql查询">
				<span class="desc oneline">1、单表查询(1)选择指定的列[例]查询全体学生的学号和姓名selectSnoas学号,Snameas姓名fromstudent;selectSno,Snamefromstudent;(2）查询全部列...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/x_i_y_u_e">来自：	<span class="blog_title"> x_i_y_u_e的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chengxuyuanyonghu/article/details/56017954","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chengxuyuanyonghu/article/details/56017954" target="_blank" title="mysql的历史命令记录，~/.mysql_history">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的历史命令<em>记录</em>，~/.<em>mysql</em>_history		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-20</span>
				<span class="read-num hover-hide">
					阅读数 
					8732</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chengxuyuanyonghu/article/details/56017954" target="_blank" title="mysql的历史命令记录，~/.mysql_history">
				<span class="desc oneline">~/.mysql_history文件中记录每个用户使用数据库的操作命令root用户的mysql操作，~/.mysql_history​transfor用户的mysql操作，/home/transfor...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chengxuyuanyonghu">来自：	<span class="blog_title"> chengxuyuanyonghu的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chinajust/article/details/78601892","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chinajust/article/details/78601892" target="_blank" title="Mysql 对SQL语句监控查看的记录">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 对<em>SQL</em><em>语句</em>监控查看的<em>记录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-22</span>
				<span class="read-num hover-hide">
					阅读数 
					3816</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chinajust/article/details/78601892" target="_blank" title="Mysql 对SQL语句监控查看的记录">
				<span class="desc oneline">mysql默认不开启sql语句跟踪监控记录，如查看sql语句执行记录，一般有下面三种方式:         1.修改配置文件，my.cnf           #vi/etc/my.cnf      ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chinajust">来自：	<span class="blog_title"> chinajust的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq5132834/article/details/79784851","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq5132834/article/details/79784851" target="_blank" title="mysql实时记录客户端提交的sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>实时<em>记录</em>客户端提交的<em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-02</span>
				<span class="read-num hover-hide">
					阅读数 
					579</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq5132834/article/details/79784851" target="_blank" title="mysql实时记录客户端提交的sql语句">
				<span class="desc oneline">mysql打开generallog后，所有的查询语句都会记录在generallog文件，文件为只读方式，但这样generallog文件会非常大，所以默认是关闭的。但有时需要查错等原因，暂时需要打开ge...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq5132834">来自：	<span class="blog_title"> qq5132834的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/pangqiandou/article/details/72355135","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/pangqiandou/article/details/72355135" target="_blank" title="历史上mysql最经典的34个SQL语句（百看不厌)">
		<h4 class="text-truncate oneline">
				历史上<em>mysql</em>最经典的34个<em>SQL</em><em>语句</em>（百看不厌)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1937</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/pangqiandou/article/details/72355135" target="_blank" title="历史上mysql最经典的34个SQL语句（百看不厌)">
				<span class="desc oneline">1:取得每个部门最高薪水的人员名称</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/pangqiandou">来自：	<span class="blog_title"> 一览众山小</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/havarduniv/article/details/44151455","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/havarduniv/article/details/44151455" target="_blank" title="查看mysql正在执行的SQL语句">
		<h4 class="text-truncate oneline">
				查看<em>mysql</em>正在执行的<em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-09</span>
				<span class="read-num hover-hide">
					阅读数 
					347</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/havarduniv/article/details/44151455" target="_blank" title="查看mysql正在执行的SQL语句">
				<span class="desc oneline">在项目开发里面总是要查看后台执行的sql语句，mysql数据库也不例外，它的查看方式大家一般喜欢使用 showprocesslist; 命令来解决，通过里面输出结果的字段解释中可以分析执行了的sql语...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/havarduniv">来自：	<span class="blog_title"> 博客标题</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/Mtzacg3sMDUtZWR1.html" target="_blank">
                        ios学习记录</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaQg3sNTEtZWR1.html" target="_blank">
                        数据库查询所有课程</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/chenxiaotong1105">
              <img src="https://avatar.csdn.net/D/1/9/3_chenxiaotong1105.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/5.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/chenxiaotong1105"  class="" id="uid">就是大同</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="7">
                        <dt><a href="https://blog.csdn.net/chenxiaotong1105?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/chenxiaotong1105?t=1"><span class="count">7</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="1">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">1</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>喜欢</dt>
            <dd><span class="count">1</span></dd>
        </dl>
        <dl class="text-center" title="0">
            <dt>评论</dt>
            <dd><span class="count">0</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="13617">
                1万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="213">
                213            </dd>
        </dl>
        <dl title="433998">
            <dt>排名：</dt>
            <dd>43万+</dd>
        </dl>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/chenxiaotong1105">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/chenxiaotong1105/article/details/83825978" target="_blank" >
                                        Data Loss Prevention (DLP)                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/chenxiaotong1105/article/details/80581358" target="_blank" >
                                        mysql恢复库表结构                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/chenxiaotong1105/article/details/56480162" target="_blank" >
                                        AliSQL安装手册                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/chenxiaotong1105/article/details/52535856" target="_blank" >
                                        mysql用户下的perl命令占用cpu高，导致系统运行缓慢                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/chenxiaotong1105/article/details/51679699" target="_blank" >
                                        安卓app，iOS二维码下载链接FIR                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/chenxiaotong1105/article/category/2836073">
                    <span class="title oneline">自动化测试</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/chenxiaotong1105/article/category/6271873">
                    <span class="title oneline">移动端测试</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/chenxiaotong1105/article/category/6417126">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/chenxiaotong1105/article/category/8318405">
                    <span class="title oneline">运维</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2018/11">
                    2018年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2018/06">
                    2018年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2017/02">
                    2017年2月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2016/09">
                    2016年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2016/06">
                    2016年6月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2015/10">
                    2015年10月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/chenxiaotong1105/article/month/2015/01">
                    2015年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/chenxiaotong1105/article/details/51679699" >
                                                安卓app，iOS二维码下载链接FIR                    </a>
					<p class="read">阅读数 <span>7319</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/chenxiaotong1105/article/details/80581802" >
                                                mysql记录所有sql语句                    </a>
					<p class="read">阅读数 <span>1709</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/chenxiaotong1105/article/details/42711987" >
                                                selenium webdriver在eclipse里面执行时报错                    </a>
					<p class="read">阅读数 <span>1517</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/chenxiaotong1105/article/details/56480162" >
                                                AliSQL安装手册                    </a>
					<p class="read">阅读数 <span>790</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/chenxiaotong1105/article/details/52535856" >
                                                mysql用户下的perl命令占用cpu高，导致系统运行缓慢                    </a>
					<p class="read">阅读数 <span>769</span></p>
				</li>
					</ul>
	</div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/chenxiaotong1105/article/details/80581358" title="mysql恢复库表结构">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/chenxiaotong1105/article/details/83825978" title="Data Loss Prevention (DLP)">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/chenxiaotong1105/article/details/80581358" title="mysql恢复库表结构">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/chenxiaotong1105/article/details/83825978" title="Data Loss Prevention (DLP)">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "80581802";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/chenxiaotong1105/article/details/80581802";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql记录所有sql语句 - chenxiaotong1105的专栏";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u8bb0\u5f55","\u6240\u6709","sql","\u8bed\u53e5"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
